inherited frmCheckFifo: TfrmCheckFifo
  Left = 428
  Top = 246
  BorderStyle = bsDialog
  Caption = #20808#36827#20808#20986#36135#21697#24322#24120#20986#24211
  ClientHeight = 306
  ClientWidth = 612
  ExplicitWidth = 618
  ExplicitHeight = 331
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlBottom: TPanel
    Top = 251
    Width = 612
    ExplicitTop = 251
    ExplicitWidth = 612
    inherited btnOK: TcxButton
      Left = 525
      Top = 8
      Default = True
      ExplicitLeft = 525
      ExplicitTop = 8
    end
    inherited btnCancel: TcxButton
      Left = 417
      Top = 8
      Visible = False
      ExplicitLeft = 417
      ExplicitTop = 8
    end
  end
  object cxLabel1: TcxLabel
    Left = 12
    Top = 12
    AutoSize = False
    Caption = #22312#32467#36134#36807#31243#20013#21457#29616#20808#36827#20808#20986#30340#36135#21697#23384#22312#36127#24211#23384#65292#19981#20801#35768#32467#36134
    Style.LookAndFeel.NativeStyle = True
    StyleDisabled.LookAndFeel.NativeStyle = True
    StyleFocused.LookAndFeel.NativeStyle = True
    StyleHot.LookAndFeel.NativeStyle = True
    Height = 16
    Width = 425
  end
  object grdFifo: TcxGrid
    Left = 9
    Top = 36
    Width = 591
    Height = 226
    Anchors = [akLeft, akTop, akRight, akBottom]
    TabOrder = 2
    object ViewFifo: TcxGridDBTableView
      Navigator.Buttons.CustomButtons = <>
      DataController.DataSource = dsFifo
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsView.ColumnAutoWidth = True
      OptionsView.GroupByBox = False
      Styles.Background = MainDM.bslBackGroup
      Styles.ContentEven = MainDM.bsEven
      Styles.ContentOdd = MainDM.bsOdd
      Styles.Selection = MainDM.bsSelect
      Styles.Header = MainDM.bsTitle
      object ViewFifodepotname: TcxGridDBColumn
        DataBinding.FieldName = 'depotname'
        HeaderAlignmentHorz = taCenter
        Width = 74
      end
      object ViewFifop_code: TcxGridDBColumn
        DataBinding.FieldName = 'p_code'
        HeaderAlignmentHorz = taCenter
        Width = 65
      end
      object ViewFifop_name: TcxGridDBColumn
        DataBinding.FieldName = 'p_name'
        HeaderAlignmentHorz = taCenter
        Width = 129
      end
      object ViewFifoeqty: TcxGridDBColumn
        DataBinding.FieldName = 'eqty'
        HeaderAlignmentHorz = taCenter
        Width = 41
      end
      object ViewFifobname: TcxGridDBColumn
        DataBinding.FieldName = 'bname'
        HeaderAlignmentHorz = taCenter
        Width = 106
      end
      object ViewFifobcode: TcxGridDBColumn
        DataBinding.FieldName = 'bcode'
        HeaderAlignmentHorz = taCenter
        Width = 65
      end
    end
    object LevelFifo: TcxGridLevel
      GridView = ViewFifo
    end
  end
  object dsFifo: TDataSource
    DataSet = qryFifo
    Left = 148
    Top = 144
  end
  object qryFifo: TUniQuery
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select a.* from'
      
        ' (select top 1 b.depotid,b.productid,s.bname, b.bcode, d.name as' +
        ' depotname,'
      ' p.code as p_code, p.name as p_name,b.eqty'
      ' from tt_bill b'
      ' join td_depot d on b.depotid=d.depotid'
      ' join td_product p on b.productid=p.p_id'
      ' join ts_billset s on b.btype=s.bid'
      ' where bdate>=:BeginDate and bdate<:EndDate'
      ' and p.calccost=4'
      ' order by b.bdate desc,b.tid desc) a'
      ' where a.eqty<0')
    CachedUpdates = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.QueryRecCount = True
    Left = 96
    Top = 148
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'BeginDate'
        Value = nil
      end
      item
        DataType = ftUnknown
        Name = 'EndDate'
        Value = nil
      end>
    object qryFifodepotid: TIntegerField
      FieldName = 'depotid'
    end
    object qryFifoproductid: TIntegerField
      FieldName = 'productid'
    end
    object qryFifobname: TStringField
      DisplayLabel = #21333#25454#31867#22411
      FieldName = 'bname'
      Size = 50
    end
    object qryFifobcode: TStringField
      DisplayLabel = #21333#25454#32534#21495
      FieldName = 'bcode'
      Size = 30
    end
    object qryFifodepotname: TWideStringField
      DisplayLabel = #20179#24211
      FieldName = 'depotname'
      Size = 60
    end
    object qryFifop_code: TStringField
      DisplayLabel = #36135#21697#32534#30721
      FieldName = 'p_code'
      Size = 30
    end
    object qryFifop_name: TWideStringField
      DisplayLabel = #36135#21697#21517#31216
      FieldName = 'p_name'
      Size = 60
    end
    object qryFifoeqty: TFloatField
      DisplayLabel = #25968#37327
      FieldName = 'eqty'
    end
  end
end
